|
DETAILED SYLLABUS DCFM
dcfm -1 COMPUTER SCIENCE AND OPERATING SYSTEMS (WINDOWS AND LINUX)
1. INTRODUCTION What is a Computer?, Purpose of using a computer, Why it is used (characteristics of computer), Instruction, Program
2. TYPES OF COMPUTER Analog, Digital, and Hybrid type, Hardware, Software, System software, Application software, Firm ware, Human ware, Stored Program Concept, Evolution of computers, Generation of computer. 3. NUMBER SYSTEMS Decimal system, Binary system, Use of binary system in digital computers, Conversion of binary to decimal and decimal to binary, Hexadecimal system and its interconversion, Alpha numeric codes-ASCII & EBCDIC
4. PROGRAMMING LANGUAGES Machine language, Assembly language, High level language,
5. ORGANISATION OF A DIGITAL COMPUTER Input unit, Output unit, Central Processing unit, Memory
6. DATA PROCESSING Data collection, Classification, Sorting and Merging, Processing, Summarising, Storing
7. DATA ORGANISATION Organisation Data, Character, Field, Record, File, Database, Sequential Access, Random Access, Indexed Sequential Access
8. PROGRAMMING PROCESS Problem Definition, Algorithm, Flowchart and coding, Testing and debugging, Implementation, Documentation, Structured Programming
9. DATA COMMUNICATION Local Area Network, Wide Area Network, Satellite Communication, Internet
10. OPERATING SYSTEM Introduction, Different Operating Systems, Loading and Quitting the Operating Systems, Important DOS Commands
WINDOWS
1. WINDOWS INTRODUCTION Operating System
2. Desk top icons My Computer, Recycle Bin, Internet Explorer, Network Neighborhood, My Documents
3. Working with windows How to create a Folder, Copying and cutting files, Renaming
4. START ICON Programs, Favorites, Documents, Settings, Find, Run, Shut down
5. APPLICATION ICONS
LINUX 1. HISTORY 2. DISTRIBUTIONS 3. DEVICES AND DRIVES IN LINUX 4. FILE SYSTEM HIERARCHY 5. COMPONENTS: KERNEL, DISTRIBUTION, SAWFISH, GNOME.
Dcfm -2 personal computer software tools (ms word, excel and powerpoint)
MS WORD
1. AN INTRODUCTION TO WORD The Word work space, Starting and quitting Word, Creating and Manipulating Various documents, Editing of proofing files, Merging documents and macros
2. HOW TO USE MOUSE AND MENU Working with dialog box
3. PRIMARY COMMANDS IN FILE MENU The Open Commands, The File name commands, The New commands, The Save, Save As, and Save all commands, The Close command, The Page setup, The Print commands, The Exit commands
4. EDIT MENU COMMANDS The Cut, Copy, and Paste commands, The Undo and Repeat commands
5. FORMAT COMMANDS Font commands, Paragraph commands
6. OTHER MENU The view menu, The Insert menu, The tool menu, The table menu, The Window menu
EXCEL
1. BUILDING A SIMPLE WORKSHEET Entering Text, Entering Values, Entering Dates and Times, Moving Around, Selecting Ranges, Using Menu, Using Tool Bar, Using Shortcut Menus, Changing Entries, Copying Entries, Moving Entries, Inserting and Deleting cells
2. FORMATTING BASICS Changing Character Style, Changing Alignment, Changing Column Width
3. WORKING WITH MULTIPLE WORKSHEET Copying entries between work books, Moving sheets between work books, Deleting sheets, Quitting Excel
4. OPENING EXISTING WORKBOOKS Simple calculations, Doing Arithmetic, Totaling column of values, Naming cells and Ranges
5. FORMATTING TEXT Displaying dollars and cents, Formatting decimal places, dates Format, Copying style and formats
6. FORMULAS THAT MAKE DECISIONS Using the IF function, Using the nested IF function, Copying formulas
7. Checking Spelling, Printing Worksheets, Preview Worksheets, Setting up the pages,
8. Sorting data, Keeping Leading in View, Finding records, Adding and deleting Records, Filtering Records
9. Plotting charts, Sizing and moving charts, Updating charts, Changing the chart type, Using chart auto format
10. Creating Macros, Recording Macros, Running Macros
Power Point
1. POWER POINT Main Features of Power Point
2. Making the Presentation Creating Template with the Auto Content Wizard. Creating a Presentation with a Template. Creating a presentation from Scratch
3 Different Views Normal Slide, Outline, Slide Sorter, Slide Show, Notes, Slide Master
4 Animation, Art and Sound Controlling Transitions between slides. Animating Different Parts of a slide. Inserting a Motion Clip. Including Sounds in slides.
5. Including Graphs, Charts, Tables and Columns Organization Chart Slide, Creating a table Slide. Creating two column Slide, Module 1: Showing A Presentation, Rehearsing/ Timing a Presentation, Designation some slides as “Hidden”, Viewing Slides Anywhere in a Slide Show.
6. Techniques for Making a Show Livelier
7. Office Connections Presenting with the help of other Office Programs Importing the text from a World Document.
8. PRINTING A PRESENTATION
dcfm -3 computer applications in financial management
I. Introduction to Accounting (1.1) What is Accounting (1.2) Financial Accounting (1.3) Books of Accounts (a) Cash (b) Journal (c) General Ledger (1.4) Classification of Accounts and Rules of Debits and Credit (1.5) Financial Statement (a) Trial Balance (b) Final Accounts Statements (c) O/S Bills Tracking (1.6) Inventory Management (a) Delivering In & Out (b)Purchase & Sales Invoice (b) Debit & Credit Notes
II. Foundation of Accounts (2.1) Ledger Accounts and Groups (2.2) Account Groups (a) Liability Side (b) Assets side (c) Income side ‘ (d) Expense side
III. Capital Account 3.1 Capital 3.2 Reserves & Surplus ( Retained Earnings)
IV. Loans (Liabilities) 4.1 Bank overdraft 4.2 Secured Loans & Unsecured Loans
V. Current Liabilities 5.1 Duties & Taxes 5.2 Provisions 5.3 Sundry Creditors 5.4 Current Liabilities
VI. Fixed Assets 6.1 Investments
VII. Current Assets 7.1 Stock in Hand 7.2 Deposits (Assets) 7.3 Loans & Advances (Assets) 7.4 Sundry Debtors 7.5 Cash in hand 7.6 Bank Account
VIII. Miscellaneous Expense & Suspense Account
IX. Sales & Purchases
X. Direct & Indirect Income
XI. Direct &Indirect Expenses XII. Voucher 12.1 Voucher Type 12.2 Voucher Class 12.3 Optional Voucher
XIII. Introduction to Tally 13.1 Tally Screen 13.2 Selection of Menu Item 13.3 Company Info Menu 13.4 Creating a new Company 13.5 Gateway 13.6 Selection of Options
13.7 Buttons at Gateway 13.8 Selection of Company
XIV.Features & Configuration 14.1 General Features 14.2 Accounting Features 14.3 Inventory Features 14.4 Account & Inventory Info 14.5 Voucher Entry 14.6 Invoice or order entry 14.7 Printing 14.8 Configuration 14.9 Account Group 14.10 Ledger Accounts 14.11 Voucher Type 14.12 Inventory Master 14.13 Stock Categories 14.14 Stock Group 14.15 Stock Items
XV Transactions 15.1 Accounts Voucher (a) Show cost centre Details (b) Show Inventory Details (c) Show table of Bills Details for selection (d) Show Bill wise Details (e) Show Ledger Current Balance (f) Show Balance as on voucher dates (g) Use Payment / Receipt as Contra (h) Allow Cash Accounts in Journals (i) Use Cr/Dr instead of To/By during Entry (j) Pre-allocate Bills for payment (k) Allow Expense/Fixed Assets in Purchase Voucher (l) Types of Voucher (m) Printing of Voucher (n) Payment Voucher – Printing (o) Receipt Voucher – Printing (p) Credit Notes – Printing (q) Debit Notes – Printing (r) Journal Voucher – Printing & Entry for closing Books of Accounts (s) Sales Voucher (t) Purchase Voucher (u) Bill – by – Bill Adjustment (v) Interest Calculation
(w) Deletion of Voucher (x) Printing of Voucher 15.2 Inventory Voucher (a) Show batch wise Details (b) Inventory Allocation
XVI Reports – Display 16.1 Display Options at Gateway 16.2 Access from Gateway 16.3 Layout of Display Screen 16.4 Buttons 16.5 Balance Sheet 16.6 Trial Balance 16.7 Account Books 16.8 Statement of Account 16.9 Day Book 16.10 List of Accounts
XVII Inventory Report Display
17.1 Stock Summary 17.2 Inventory Books (a) Stock Item (b) Group Summary (c) Movement Analysis 17.3 Stock Transfer 17.4 Physical Stock Register 17.5 Sales Order Book 17.6 Purchase Order Book 17.7 Viewing Order position
XVIII MIS Reports – Display 18.1 Printing while viewing reports 18.2 Common Printing Options 18.3 Reports Specific Printing Configuration 18.4 Balance Sheet 18.5 Profit & Loss Account 18.6 Trial Balance & Other Group Summary Reports 18.7 Day Books 18.8 Ledger monthly Summary 18.9 Registers 18.10 Outstanding (receivable & payable)
XIX Outstanding (Ledger & Groups) 19.1 Cash & funds flow 19.2 Cash & funds flow (summary) 19.3 Stock Summary 19.4 Stock Item monthly Summary 19.5 Account books (a) Cash Book (b) Bank Book (c) Ledger Book (i) All A/C (ii) One A/C (iii) Group A/C
dcfm -4 software lab
dcfm -5 project
dcfm -6 seminar
| ||||||||||||||||||||||||